Release 10.1A: OpenEdge Data Management:
SQL Reference

SQLCursor.getValue

Assigns a single value from an SQL result set to a procedure variable. The single field value is the result of an SQL query or the result from another stored procedure.

Format

public Object getValue( int fieldNum, short fieldType )

Returns

Object

Parameters

fieldNum

An integer that specifies the position of the field to retrieve from the fetched record.

fieldType

A short integer that specifies the data type of the parameter. The allowable defined values for fieldType are listed in Table 56, grouped by category of data type.

Table 56: Allowable values for fieldType in getValue 

Character	Exact numeric	Approximate numeric	Date-time	Bit string
CHAR	INTEGER	REAL	DATE	BIT
CHARACTER	SMALLINT	FLOAT	TIME	BINARY
VARCHAR	TINYINT	DOUBLE	TIMESTAMP	VARBINARY
–	NUMERIC	–	–	LVARBINARY
–	DECIMAL	–	–	–

Throws

DhSQLException

Notes

Before invoking getValue, you must test for the NULL condition by calling the SQLCursor.wasNULL method. If the value returned is NULL, you must explicitly set the target variable in the stored procedure to NULL.
The getValue method returns a value from the result set identified by the number you specify in the fieldNum parameter. getValue returns the value as an object of the data type you specify in the fieldType parameter. Since getValue returns the result as an instance of class Object, you must explicitly cast your return value to the correct data type.
If the returned value is of data type CHARACTER, then getValue returns a Java String Object. You must declare a procedure variable of type String and explicitly cast the value returned by getValue to type String.

Example

This example illustrates testing for NULL and invoking the Java getValue method:

Integer pvar_int = new Integer(0); String pvar_str = new String(); SQLCursor select_t1 = new SQLCursor ("select int_col, char_col from T1"); Select_t1.open(); Select_t1.fetch(); while(select_t1.found()) { // Assign values from the current row of the SQL result set // to the procedure variables. First check whether // the values fetched are null. If null then explicitly // set the procedure variables to null. if ((select_t1.wasNULL(1)) == true) pvar_int = null; else pvar_int = (Integer)select_t1.getValue(1, INTEGER); if ((select_t1.wasNULL(2)) == true) pvar_str = null; else pvar_str = (String)select_t1.getValue(1, CHAR); }